Adding a SQL expression

Note:    You must have some familiarity with the SQL language and SQL expressions before trying to add an expression to your query file.

1. Click Expression.

   The SQL Expression dialog box appears.

   

2. Type a name for the new expression, then click OK.

   The SQL Expression dialog box appears.

3. Double-click on a field in the Fields area to add it to the expression.

   The field moves into the SQL area.

4. Edit the expression if needed.
5. Click OK when you have finished.
6. Select the new SQL expression.

   It will be indicated by an @ sign.

7. Click Add.

   The field is added to the Query Fields list.